4
I have a dropdown which populates from a database.
When user selects option 1 from the dropdown, he should be directed to sample.php, if he selects option 2, then to sampleb.php and so on.
The code is as follows:
Expand|Select|Wrap|Line Numbers
- <html>
- <head>
- <script language="JavaScript">
- function go(formname,url){
- document.getElementById(myteam).action = url;
- document.getElementById(myteam).submit();
- }
- </script>
- </head>
- <title>Homepage</title>
- <?php
- //dbconnect is a file which has the connection paramaters
- //to the server and the database.
- require ("dbconnect.php");
- $sqlquery="SELECT teamqueuename FROM teamqueue;";
- $results= mssql_query($sqlquery);
- ?>
- <body>
- <table>
- <tr><td><center>Welcome to the homepage!</center><td></tr>
- <tr><td><br></td></tr>
- <tr><td>Please select a team queue</td></tr>
- <form name="myteam" method="get" target="_blank">
- <tr><td><select name="myteam1" onChange="call()">
- <?php
- while ($row=mssql_fetch_array($results)){
- $teamqueuename=$row["teamqueuename"];
- echo "<option>$teamqueuename</option>";
- }
- mssql_close($sqlconnect);
- ?>
- </select></td></tr>
- <tr><td><input type="submit" value="submit"></td></tr>
- </form>
- <?php
- function call(){
- $myteam=$_get['myteam'];
- if ($myteam=="Build Team")
- {
- go(myteam, "http://sample.php");
- }
- if ($myteam=="PPG Team")
- {
- go(myteam, "http://sampleb.php");
- }
- }
- ?>
- </table>
- </body>
- </html>
Thank you..
